
 Ʒ԰ Version 2.0.0 SQL ߼ҵ                           
 Ȩ: Ʒ԰(rjian.zhgzyy.cn)                             
ǩ
 Copyright 2002-2005 newasp.net - All Rights Reserved.              
 newasp is a trademark of newasp.net                                
ǩ
Ȩ                                                        
 Ϊ(shareware)ṩվҵվʹá        
 ԶԱϵͳ޸ĺ뱣İȨϢ           
 ý޸ĺİ汾κҵĿ;                                
 л񹲺͹Ȩط 
 汣߱һȨ                                       
ǩ
 ļƣMSSQLװض                                            


ǵһʹñϵͳȷͬnewasp.netİȨϸĶ˵ĵ

1ҵ

2½һݿ ݿԶ

3򿪹-SQL ѯnewasp.sqlļڡSQLݿⰲװĿ¼棩

4ɺݿnewasp_sql.mdbļڡSQLݿⰲװĿ¼棩

ϸ:
======================================================
һ½ݿ
---------------------------
  ҵ -- չSQL Server 顱 -- ݿ⡱(Ҽ) -- ½ݿ⡱(ݿԶԻ) -- ݿ(ݿӢ)ȷ

ڶSQLűѯ
---------------------------
  ѡ½ݿ -- ѡ񹤾ϵġߡ˵ -- SQL ѯ -- װSQLűݼCtrl+Shift+P-- 򿪡newasp.sql --
  -ѡ񹤾ϵġѯ(Q)˵ -- (P)ݼCtrl+F5-- ʾѳɹɡ --
  -ѡ񹤾ϵġѯ(Q)˵ -- ִ(E)ݼF5-- ʾѳɹɡ -- رSQLѯһ

ݿ
----------------------------
  ѡ½ݿҼ -- (K) -- (E) -- һ -- 
  - 򿪡DTS /򵼡 -- Դ(D)ѡMicrosoft Access -- ļ(F)ѡnewasp_sql.mdb -- һ --
  -ѡĿ -- ݿ(D)ѡղ½ݿ⣬ĬϾ -- һ -- ݿ⸴Ʊͼ -- һ --
  -ͼȫѡ-- һ-- С-- һ -- ʾ -- ȷɡ

Ĳ½ݿû
---------------------------
  չ̨Ŀ¼ -- ȫԡ -- ¼ -- Ҽ½¼ -- ½û¼Ի --
  -ơûӢ -- ѡSQL Server֤(S) --  -- ݿ(D)ѡղ½ݿ --
  -лݿʡ -- ѡղ½ݿ -- ݿɫ -- ѡpublicdb_owner -- ȷ --ʾٴ -- 

岽޸ݿ
  ü±򿪸Ŀ¼ġconn.asp--޸ݿӲ
  ݿ1ΪSQLݿ⣬0ΪAccessݿ
  Const isSqlDataBase = 1

  SqlDatabaseName = "newasp"       'ݿղ½ݿ
  SqlUsername = "sa"              'ûղ½ĵ¼
  SqlPassword = "newasp"          'û룬ղ½ĵ¼
  SqlLocalName = "(local)"        '(local)IPġSQLҵ͡IISͬһ̨Ͳ޸
  ϲȫдڡ""˫м䣬conn.asp

վ
  ַʼҳʱҳʾ벻Ҫţ¼̨admin/admin_login.aspĬû룺admin
  ¼̨ --  --  -- ޸Ļ -- 롰ؽ桱 -- 
  Խˣ½ࡢ¡ӹ桢ȡ

  ڿɾDatabaseĿ¼µġnewasp.sql͡newasp_sql.mdbļ

----------- ½SQLݿȫ----------


                       Ʒ԰                               
                                                                
               ַhttp://rjian.zhgzyy.cn                     
                                                                
                       QQ:200823945                             
                                                                
                E_MAIL:   xunxcn@163.com                        
